Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
OperatorID (FK)(PK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | OperatorHistory(LE_HST_OPR) |
OperatorTender (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | OperatorHistory(LE_HST_OPR) |
TotalTenderMediaCount | The total number of tender media units counted by operator for each REPORTING PERIOD. | QU_MD_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderMediaOverCount | The total tender overage recorded against an operator for each REPORTING PERIOD. | QU_MD_TND_OVR_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderMediaShortCount | The total monetary value of tender shortages recorded for that OPERATOR for each REPORTING PERIOD. | QU_MD_TND_SHRT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalBeginningTenderMediaUnitCount | The open balance of the number of tender media units for that OPERATOR for each REPORTING PERIOD. | QU_MD_TND_BGN_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderLoanMediaUnitCount | The total number of tender media units loaned by operator for each REPORTING PERIOD. | QU_MD_TND_LN_TOT | QuantityTransactionCount | decimal(7,0) | |
LoanMediaTotalAmount | The total monetary amount of tender media units loaned by operator for each REPORTING PERIOD. | CP_MD_LON_TND_TOT | Money | decimal(16,5) | |
TotalTenderPickupMediaUnitCount | The total number of tender media units picked up by operator for each REPORTING PERIOD. | QU_MD_TND_PKP_TOT | QuantityTransactionCount | decimal(7,0) | |
PickupMediaTotalAmount | The total monetary amount of tender media units picked up by operator for each REPORTING PERIOD. | CP_MD_TND_PKP_TOT | Money | decimal(16,5) | |
DepositTotalAmount | The total monetary value of tender media deposited in the EXTERNAL DEPOSITORY by OPERATOR for each REPORTING PERIOD. | CP_DS_TND_TOT | Money | decimal(16,5) | |
TotalTenderDepositMediaUnitCount | The total number of tender media units deposited in the EXTERNAL DEPOSITORY by OPERATOR for each REPORTING PERIOD. | QU_MD_TND_DS_TOT | QuantityTransactionCount | decimal(7,0) | |
OverTotalAmount | The total monetary value of tender overages recorded by OPERATOR for each REPORTING PERIOD. | CP_TND_OVR_TOT | Money | decimal(16,5) | |
ShortTotalAmount | The total monetary value of tender shortages recorded for that OPERATOR for each REPORTING PERIOD. | CP_TND_SHRT_TOT | Money | decimal(16,5) | |